package com.foreknow.elmboot.mapper;

import com.foreknow.elmboot.po.DeliveryAddress;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface DeliveryAddressMapper {

    @Select("select address from deliveryAddress where userId=#{userId}")
    public List<DeliveryAddress> listDeliveryAddressByUserId  (String userId);

    @Select("select address from deliveryAddress where daId=#{daId} ")
    public DeliveryAddress getDeliveryAddressById(Integer daId);

    @Insert("insert into deliveryAddress (contactName,contactSex,contactTel,address,userId ) values(#{contactName},#{contactSex},#{contactTel},#{address},#{userId})")
    public int saveDeliveryAddress(DeliveryAddress deliveryAddress);

    @Update("update deliveryAddress set daId=#{daId},contactName=#{contactName},contactSex=#{contactSex},contactTel=#{contactTel},userId=#{userId } where address=#{address}")
    public int updateDeliveryAddress(DeliveryAddress deliveryAddress);

    @Delete("delete from deliveryAddress where daId=#{daId}")
    public int removeDeliveryAddress(Integer daId);
}
